package org.shoukaiseki.supersaiyan.db.inittable.system;

import org.shoukaiseki.inittable.domain.TableColumnInfo;
import org.shoukaiseki.inittable.service.ITableBuildInfoService;
import org.shoukaiseki.kakaroto.annotation.TableBuild;

import java.util.List;

import static org.shoukaiseki.inittable.utils.SksColumnCamelCaseCommon.*;
import static org.shoukaiseki.inittable.utils.SksColumnCamelCaseCommon.rowstamp;
import static org.shoukaiseki.inittable.utils.TableColumnInfoBuilder.column;
import static org.shoukaiseki.inittable.utils.TableInfoUtils.tableColumns;


/**
 * OK
 * org.shoukaiseki.supersaiyan.db.inittable.system.SysPostInitTable
 * <br>
 *
 * @author shoukaiseki blog http://www.shoukaiseki.top/<br> E-mail jiang28555@Gmail.com<br>
 * @date 2022-10-10 16:58:36<br>
 */
@TableBuild(name = "sys_post", comment = "岗位信息表",version = 1)
public class SysPostInitTable implements ITableBuildInfoService {


    @Override
    public List<TableColumnInfo> tableColumnInfoList(){
        List<TableColumnInfo> table = tableColumns(

                uniqueId("post_id","角色ID"),
                column("    post_code   varchar(64)            not null comment '岗位编码',"),
                column("	post_name   varchar(50)            not null comment '岗位名称',"),
                column("	post_sort   int(20) default 0      not null comment '显示顺序',"),
                column("	remark      varchar(500)           null comment '备注'"),
                status(),
                siteId(),
                orgId(),
                deptId(),
                createUserId(),
                createTime(),
                updateUserId(),
                updateTime(),
                delFlag(),
                rowstamp(),
                null
        );

        return table;
    }

}
